﻿CREATE TABLE [dbo].[MemberProfile] (
    [UserId]                 UNIQUEIDENTIFIER NOT NULL,
    [FirstName]              NVARCHAR (64)    NOT NULL,
    [LastName]               NVARCHAR (64)    NOT NULL,
    [Bio]                    NVARCHAR (2048)  NOT NULL,
    [PhotoID]                UNIQUEIDENTIFIER NULL,
    [AllowAnonymizedContact] BIT              NOT NULL,
    [AllowPublicProfile]     BIT              NOT NULL,
    [EmailOptIn]             INT              NOT NULL
);

